<?php
include("config.php");
require_once("auth.php");
$comName=$_POST['txtCompanyName'];
$sname=$_POST['txtSupplierName'];
$city=$_POST['txtCity'];
$add=$_POST['textAdd'];
$state=$_POST['txtState'];
$country=$_POST['txtCountry'];
$postalc=$_POST['txtPostalCode'];
$ph=$_POST['txtPhone'];
$email=$_POST['txtEmail'];
$goods=$_POST['txtTypeGoods'];
$cod=$_POST['textcurrOrderDetails'];
$custid=$_POST['ddlCustomerId'];
$id=$_POST['id'];
$data=mysql_query("UPDATE  `suppliers` SET  `SupplierName` ='$sname',CompanyName='$comName',Address='$add',City='$city',State='$state',Country='$country',Phone='$ph',Email='$email',TypeGoods='$goods',Curr_Ord_Details='$cod',CustomerID='$custid' where SupplierID=$id");

if($data)
{
header("location: displaysuppliers.php?updated=updated");
}
else
{
echo mysql_error();
}
?>